package com.showde.shoppingmall.db.constant;

public class ProductCollectionConstant extends ConstantBase {

	public static final String TABLE_NAME = "'t_collection'";

	public static final String PRODUCTID = "PRODUCTID";
	public static final String PRODUCTTITLE = "PRODUCTTITLE";
	public static final String PRODUCTLOGO = "PRODUCTLOGO";
	public static final String PRODCUTTIME = "PRODCUTTIME";

	public static final int COLUMN_PRODUCTID = 1;
	public static final int COLUMN_PRODUCTTITLE = 2;
	public static final int COLUMN_PRODUCTLOGO = 3;
	public static final int COLUMN_PRODUCTTIME = 4;

	public static final String[] columns = new String[] { PRODUCTID,
			PRODUCTTITLE, PRODUCTLOGO, PRODCUTTIME };

	public static final String SQL_CREATE = "create table 't_collection'("
			+ "'_id' int primary key, "
			+ "'PRODUCTID' varchar(20) not null unique, "
			+ "'PRODUCTTITLE' varchar(100), " + "'PRODUCTLOGO' varchar(200), "
			+ "'PRODCUTTIME' varchar(50))";

}
